﻿CREATE TABLE [dbo].[hlpLog] (
    [LogID]       INT            IDENTITY (1, 1) NOT NULL,
    [UserID]      INT            NOT NULL,
    [LogType]     NCHAR (10)     NOT NULL,
    [LogArea]     NCHAR (10)     NOT NULL,
    [LogDateTime] DATETIME2 (7)  CONSTRAINT [DF_hlpLog_LogDateTime] DEFAULT (sysdatetime()) NOT NULL,
    [LogDetails]  NVARCHAR (MAX) NOT NULL,
    [IsError]     BIT            CONSTRAINT [DF_hlpLog_IsError] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_hlpLog] PRIMARY KEY CLUSTERED ([LogID] ASC)
);

